<template>
  <view>
    <view class="uni-header">
      <view class="uni-group">
        <view class="uni-title"></view>
        <view class="uni-sub-title"></view>
      </view>
      <view class="uni-group">
        <input class="uni-search" type="text" v-model="query" @confirm="search" placeholder="请输入搜索内容" />
        <button class="uni-button" type="default" size="mini" @click="search">搜索</button>
        <button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
        
      </view>
    </view>
    <view class="uni-container">
      <unicloud-db ref="udb" :collection="collectionList" :where="where" page-data="replace"
        :orderby="orderby" :getcount="true" :page-size="options.pageSize" :page-current="options.pageCurrent"
        v-slot:default="{data,pagination,loading,error,options}" :options="options" loadtime="manual" @load="onqueryload">
        <uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe type="selection" @selection-change="selectionChange">
          <uni-tr>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'title')" sortable @sort-change="sortChange($event, 'title')">标题</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'avatar')" sortable @sort-change="sortChange($event, 'avatar')">封面大图</uni-th>
			<uni-th align="center">分类</uni-th>
			<!-- <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'price')" sortable @sort-change="sortChange($event, 'price')">价格</uni-th> -->
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'content')" sortable @sort-change="sortChange($event, 'content')">课程内容</uni-th>
            <uni-th align="center" sortable @sort-change="sortChange($event, 'videofile')">视频文件</uni-th>
            <uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'excerpt')" sortable @sort-change="sortChange($event, 'excerpt')">摘要</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.article_status_localdata" @filter-change="filterChange($event, 'article_status')">状态</uni-th>
            <uni-th align="center" filter-type="select" :filter-data="options.filterData.isChapter_localdata" @filter-change="filterChange($event, 'isChapter')">开放章节</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'publish_date')" sortable @sort-change="sortChange($event, 'publish_date')">发表时间</uni-th>
            <uni-th align="center" filter-type="timestamp" @filter-change="filterChange($event, 'last_modify_date')" sortable @sort-change="sortChange($event, 'last_modify_date')">最后修改时间</uni-th>
            <uni-th align="center">操作</uni-th>
          </uni-tr>
          <uni-tr v-for="(item,index) in data" :key="index">
            <uni-td align="center">{{item.title}}</uni-td>
			<uni-td align="center">
				<image  :src="item.avatar.url" style="width: 100px;" mode="widthFix"></image>
				
			</uni-td>
			<uni-td align="center">{{item.category_id && item.category_id[0] && item.category_id[0].text}}</uni-td>
			
            <!-- <uni-td align="center">{{item.price}}</uni-td> -->
            <uni-td align="center">{{item.content}}</uni-td>
            <uni-td align="center">
              <uni-file-picker v-if="item.videofile && item.videofile.fileType == 'image'" :value="item.videofile" :file-mediatype="item.videofile && item.videofile.fileType" return-type="object" :imageStyles="imageStyles" readonly></uni-file-picker>
              <uni-link v-else :href="item.videofile && item.videofile.url" :text="item.videofile && item.videofile.url"></uni-link>
            </uni-td>
            <uni-td align="center">{{item.excerpt}}</uni-td>
            <uni-td align="center">{{options.article_status_valuetotext[item.article_status]}}</uni-td>
            <uni-td align="center">{{options.isChapter_valuetotext[item.isChapter]}}</uni-td>
         
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.publish_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
              <uni-dateformat :threshold="[0, 0]" :date="item.last_modify_date"></uni-dateformat>
            </uni-td>
            <uni-td align="center">
              <view class="uni-group">
                <button @click="navigateTo('./edit?id='+item._id, false)" class="uni-button" size="mini" type="primary">修改</button>
                <!-- <button @click="confirmDelete(item._id)" class="uni-button" size="mini" type="warn">删除</button> -->
				<button class="uni-button" type="warn" size="mini" @click="open(item._id)">二维码开通</button>
              </view>
            </uni-td>
          </uni-tr>
        </uni-table>
        <view class="uni-pagination-box">
          <uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current" :total="pagination.count" @change="onPageChanged" />
        </view>
      </unicloud-db>
    </view>
	<uni-popup ref="popup" type="center" :mask-click="false">
		<view class="popup-content">
			<uni-forms ref="form" label-width="100px">
			 <uv-qrcode ref="qrcode" size="300px" :value="codeText" v-show="codeText"></uv-qrcode>
			 <view class="uni-button-group">
				<button type="primary" class="uni-button" style="width: 100px;margin-right: 10px;" @click="save()">下载</button>
				<button class="uni-button" style="width: 100px;"  @click="close()">关闭</button>
			  </view>
			</uni-forms>
		</view>
	</uni-popup>
  </view>
</template>

<script>
  import { enumConverter, filterToWhere } from '../../js_sdk/validator/mydb-course-list.js';

  const db = uniCloud.database()
  // 表查询配置
  const dbOrderBy = '' // 排序字段
  const dbSearchFields = [] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
  // 分页配置
  const pageSize = 20
  const pageCurrent = 1

  const orderByMapping = {
    "ascending": "asc",
    "descending": "desc"
  }

  export default {
    data() {
      return {
        collectionList: [ db.collection('mydb-course-list').field('user_id,category_id,title,price,content,videofile,excerpt,article_status,comment_status,isChapter,last_comment_user_id,avatar,publish_date,last_modify_date,mode').getTemp(),db.collection('mydb-course-categories').field('name as text, _id').getTemp() ],
        query: '',
        where: '',
        orderby: dbOrderBy,
        orderByFieldName: "",
        selectedIndexs: [],
		course_id:"",
		codeText:"",
        options: {
          pageSize,
          pageCurrent,
          filterData: {
            "article_status_localdata": [
              {
                "value": 0,
                "text": "草稿箱"
              },
              {
                "value": 1,
                "text": "已发布"
              }
            ],
            "comment_status_localdata": [
              {
                "value": 0,
                "text": "关闭"
              },
              {
                "value": 1,
                "text": "开放"
              }
            ],
            "isChapter_localdata": [
              {
                "value": 0,
                "text": "关闭"
              },
              {
                "value": 1,
                "text": "开放"
              }
            ]
          },
          ...enumConverter
        },
        imageStyles: {
          width: 64,
          height: 64
        },
        exportExcel: {
          "filename": "mydb-course-list.xls",
          "type": "xls",
          "fields": {
            "user_id": "user_id",
            "分类": "category_id",
            "标题": "title",
            "价格": "price",
            "课程内容": "content",
            "视频文件": "videofile",
            "课程摘录": "excerpt",
            "课程状态": "article_status",
            "开放评论": "comment_status",
            "开放章节": "isChapter",
            "last_comment_user_id": "last_comment_user_id",
            "封面大图": "avatar",
            "发表时间": "publish_date",
            "最后修改时间": "last_modify_date",
            "排版显示模式": "mode"
          }
        },
        exportExcelData: []
      }
    },
    onLoad() {
      this._filter = {}
    },
    onReady() {
      this.$refs.udb.loadData()
    },
    methods: {
		open(id){
			let time=new Date().getTime()
			this.codeText=`https://static-mp-e3fbd118-dad0-4878-b40b-44597e7aa0eb.next.bspapp.com/admin/#/pages/mydb-course-catch/open?id=${id}&time=${time}`
			this.$refs.popup.open()
			setTimeout(()=>{
				this.$refs.qrcode.remake({
				 success: () => {
				   console.log('生成成功');
				 },
				 fail: err => {
				   console.log(err)
				 }
				});
			},300)
		},
		close() {
			this.$refs.popup.close()
		},
		save(){
			this.$refs.qrcode.save({
			 success: (res) => {
			   console.log(res);
			 }
			});
		},
		changeCourse(e){
			console.log(e)
		},
      onqueryload(data) {
        this.exportExcelData = data
      },
      getWhere() {
        const query = this.query.trim()
        if (!query) {
          return ''
        }
        const queryRe = new RegExp(query, 'i')
        return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
      },
      search() {
        const newWhere = this.getWhere()
        this.where = newWhere
        this.$nextTick(() => {
          this.loadData()
        })
      },
      loadData(clear = true) {
        this.$refs.udb.loadData({
          clear
        })
      },
      onPageChanged(e) {
        this.selectedIndexs.length = 0
        this.$refs.table.clearSelection()
        this.$refs.udb.loadData({
          current: e.current
        })
      },
      navigateTo(url, clear) {
        // clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
        uni.navigateTo({
          url,
          events: {
            refreshData: () => {
              this.loadData(clear)
            }
          }
        })
      },
      // 多选处理
      selectedItems() {
        var dataList = this.$refs.udb.dataList
        return this.selectedIndexs.map(i => dataList[i]._id)
      },
      // 批量删除
      delTable() {
        this.$refs.udb.remove(this.selectedItems(), {
          success:(res) => {
            this.$refs.table.clearSelection()
          }
        })
      },
      // 多选
      selectionChange(e) {
        this.selectedIndexs = e.detail.index
      },
      confirmDelete(id) {
        this.$refs.udb.remove(id, {
          success:(res) => {
            this.$refs.table.clearSelection()
          }
        })
      },
      sortChange(e, name) {
        this.orderByFieldName = name;
        if (e.order) {
          this.orderby = name + ' ' + orderByMapping[e.order]
        } else {
          this.orderby = ''
        }
        this.$refs.table.clearSelection()
        this.$nextTick(() => {
          this.$refs.udb.loadData()
        })
      },
      filterChange(e, name) {
        this._filter[name] = {
          type: e.filterType,
          value: e.filter
        }
        let newWhere = filterToWhere(this._filter, db.command)
        if (Object.keys(newWhere).length) {
          this.where = newWhere
        } else {
          this.where = ''
        }
        this.$nextTick(() => {
          this.$refs.udb.loadData()
        })
      }
    }
  }
</script>

<style scoped>
	.popup-content{
		padding: 20px;
		background-color: #fff;
		border-radius: 10px;
	}
</style>
